package com.intelligentcar.springboot.mapper;

import com.intelligentcar.springboot.bean.Proposal;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ProposalMapper {

    //    条件查询
    List<Proposal> LookLook1(Proposal proposal);

    List<Proposal> LookproposalTime(@Param(value = "proposalTime")String proposalTime);

    //展示所有
    List<Proposal> LookProposal();

    //查询总条数
    int selectProposal();

    //修改公告信息

    int updateProposal(@Param(value = "id")long id,
                       @Param(value = "uid")long uid,
                       @Param(value = "proposalMessage")String proposalMessage,
                       @Param(value = "proposalPicture")String proposalPicture,
                       @Param(value = "proposalTime")String proposalTime,
                       @Param(value = "state")String state,
                       @Param(value = "response")String response);
//
//    //删除公告
//    int delete(long id);
//
//    //增加公告
//    int add(News news);

}
